/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using DGZImp.SysEntity;

namespace ATkg.BizAppProject.DomainModels
{
    [Entity(TableCnName = "三地采购申请信息汇总",TableName = "Purchase_Requisition",DBServer = "ServiceDbContext")]
    public partial class Purchase_Requisition:ServiceEntity
    {
        /// <summary>
       ///
       /// </summary>
       [Display(Name ="year")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string year { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="month")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string month { get; set; }

       /// <summary>
       ///
       /// </summary>
       [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
       [Key]
       [Display(Name ="id")]
       [Column(TypeName="int")]
       [Required(AllowEmptyStrings=false)]
       public int id { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="product_name")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string product_name { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="spec")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string spec { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="request_qty")]
       [DisplayFormat(DataFormatString="10,2")]
       [Column(TypeName="decimal")]
       [Editable(true)]
       public decimal? request_qty { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="date_required")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? date_required { get; set; }

       /// <summary>
       ///1:月度计划，2：临时计划
       /// </summary>
       [Display(Name ="1:月度计划，2：临时计划")]
       [Column(TypeName="int")]
       [Editable(true)]
       public int? request_type { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="reason")]
       [Column(TypeName="nvarchar(max)")]
       [Editable(true)]
       public string reason { get; set; }

       /// <summary>
       ///1:北京空港，2：安泰爱科，3：安泰北方
       /// </summary>
       [Display(Name ="1:北京空港，2：安泰爱科，3：安泰北方")]
       [Column(TypeName="int")]
       [Editable(true)]
       public int? factory { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="purchase_state")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string purchase_state { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="purchase_date")]
       [MaxLength(255)]
       [Column(TypeName="nvarchar(255)")]
       [Editable(true)]
       public string purchase_date { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="purchase_notes")]
       [Column(TypeName="nvarchar(max)")]
       [Editable(true)]
       public string purchase_notes { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="last_update_on")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? last_update_on { get; set; }

       /// <summary>
       ///
       /// </summary>
       [Display(Name ="mes_id")]
       [Column(TypeName="int")]
       public int? mes_id { get; set; }

       
    }
}